
DROP TABLE IF EXISTS jms_dm.dm_fwzl_over_nomarl_delivery_site_sum;

create external table jms_dm.dm_fwzl_over_nomarl_delivery_site_sum
(
arrival_scan_time date comment '扫描时间',
pick_network_code string comment '寄件网点code',
pick_network_name string comment '寄件网点名称',
pick_agent_code string comment '寄件代理区code',
pick_agent_name string comment '寄件代理区',
delivery_time date comment '寄件时间',
over_nomarl_type string comment '超标类型',
scan_center_arrival_cnt decimal(16,2) comment '扫描中心到件量',
over_nomarl_cnt decimal(16,2) comment '超标件票数',
finish_record_cnt decimal(16,2) comment '已备案票数',
no_record_cnt decimal(16,2) comment '未备案票数'
)
COMMENT '服务质量-超标件网点汇总'
PARTITIONED BY ( dt STRING COMMENT '')
STORED AS PARQUET
LOCATION '/dw/hive/jms_dm.db/external/dm_fwzl_over_nomarl_delivery_site_sum'
TBLPROPERTIES (
    'discover.partitions' = 'false',
    'parquet.column.index.access' = 'true'
    );
